Oracle

# determine the largest single chunk of free space available in the tablespace
select tablespace_name,sum(bytes/1024/1024),max(bytes/1024/1024) from dba_free_space group by tablespace_
name;
# Coalesce a tablespace :
alter tablespace ICT_SNAP_DATA coalesce